delete from PulsatrixStagingDb.dbo.RealvnzDb_Department;
delete from PulsatrixStagingDb.dbo.RealvnzDb_City;
delete from PulsatrixStagingDb.dbo.RealvnzDb_Region;

insert into PulsatrixStagingDb.dbo.RealvnzDb_Region (RegionId, Name)
select RegionId, Name
from realvnzDb.dbo.Region;

insert into PulsatrixStagingDb.dbo.RealvnzDb_City (CityId, RegionId, Name)
select CityId, RegionId, Name
from realvnzDb.dbo.City;

insert into PulsatrixStagingDb.dbo.RealvnzDb_Department (DepartmentId, Name, RegionId)
select DepartmentId, Name, RegionId
from realvnzDb.dbo.Department;